********************************************************************************
*																			   *
*						Sir! I'd Rather Go to School Sir!					   *
*																			   *
*								 Mahdi Majbouri								   *
*																			   *
*									Table G									   *
*																			   *
*									6-6-2023								   *
*																			   *
********************************************************************************


******************************** Initialization ********************************
clear
* clean data location
global data = "C:\Users\mmajbouri\Dropbox\Sarbazi\data"	

* where results should be saved				
global results = "C:\Users\mmajbouri\Dropbox\Sarbazi\results\6-6-23"
********************************************************************************

********************************************************************************
**  Finding the average wage for various job categories
********************************************************************************


** All Men and Women Aged 20 to 28	
use "$data\06-12-sons-wages.dta", clear

********** EDUCATION
replace age = . if age >= 998

keep if age >= 23 & age <= 28
keep if gender == 1

keep if urban == 1

replace job = . if job>=9980
gen jobcat = int(job/1000) if job>=120

/*
mean lgmwage, over(jobcat) 
11.79569
11.81778
11.49667
11.45292
11.02354
11.15699
11.13624
11.27502
11.1698
*/

gen h = hpday * dpweek * 4
gen gmw = gmsalary / h

mean gmw, over(jobcat)

/*
10.331495
10.085716
9.7432507
9.7092485
9.4013557
9.4451785
9.5111654
9.5588096
9.4004441
*/